<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

	<?php
	
		include "conecta.php";
		
		$sql = "select 
						noticia.id,titulo,texto,nome 
				from 
						noticia,categoria
						
				where 
						categoria.id = noticia.categoria_id order by noticia.id desc limit 10";
		
		$resultado = mysql_query($sql);
		
		while ($conteudo = mysql_fetch_array($resultado)) {
		
			$titulo = $conteudo["titulo"];
			$texto = $conteudo["texto"];
			$categoria = $conteudo["nome"];
			
			echo "<h2>".$titulo."</h2>";
			echo "<table width='100%'><tr><td width='100%'>".$texto."</td></tr></table>";
		}
	?>

</body>
</html>
